<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateGongrFinishesTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('gongr_finishes', function(Blueprint $table)
		{
			$table->increments('id');
			$table->integer('gr_id');
			$table->string('gr_name', 100)->nullable();
			$table->string('month', 100)->nullable();
			$table->string('gb_name', 100)->nullable();
			$table->string('gr_gz', 100)->nullable();
			$table->string('1_gb', 100)->nullable();
			$table->string('1_gx', 100)->nullable();
			$table->string('1_time', 100)->nullable();
			$table->dateTime('1_start')->nullable();
			$table->dateTime('1_end')->nullable();
			$table->integer('1_finish')->nullable();
			$table->string('2_gb', 100)->nullable();
			$table->string('2_gx', 100)->nullable();
			$table->string('2_time', 100)->nullable();
			$table->dateTime('2_start')->nullable();
			$table->dateTime('2_end')->nullable();
			$table->integer('2_finish')->nullable();
			$table->string('3_gb', 100)->nullable();
			$table->string('3_gx', 100)->nullable();
			$table->string('3_time', 100)->nullable();
			$table->dateTime('3_start')->nullable();
			$table->dateTime('3_end')->nullable();
			$table->integer('3_finish')->nullable();
			$table->string('4_gb', 100)->nullable();
			$table->string('4_gx', 100)->nullable();
			$table->string('4_time', 100)->nullable();
			$table->dateTime('4_start')->nullable();
			$table->dateTime('4_end')->nullable();
			$table->integer('4_finish')->nullable();
			$table->string('5_gb', 100)->nullable();
			$table->string('5_gx', 100)->nullable();
			$table->string('5_time', 100)->nullable();
			$table->dateTime('5_start')->nullable();
			$table->dateTime('5_end')->nullable();
			$table->integer('5_finish')->nullable();
			$table->string('6_gb', 100)->nullable();
			$table->string('6_gx', 100)->nullable();
			$table->string('6_time', 100)->nullable();
			$table->dateTime('6_start')->nullable();
			$table->dateTime('6_end')->nullable();
			$table->integer('6_finish')->nullable();
			$table->string('7_gb', 100)->nullable();
			$table->string('7_gx', 100)->nullable();
			$table->string('7_time', 100)->nullable();
			$table->dateTime('7_start')->nullable();
			$table->dateTime('7_end')->nullable();
			$table->integer('7_finish')->nullable();
			$table->string('8_gb', 100)->nullable();
			$table->string('8_gx', 100)->nullable();
			$table->string('8_time', 100)->nullable();
			$table->dateTime('8_start')->nullable();
			$table->dateTime('8_end')->nullable();
			$table->integer('8_finish')->nullable();
			$table->string('9_gb', 100)->nullable();
			$table->string('9_gx', 100)->nullable();
			$table->string('9_time', 100)->nullable();
			$table->dateTime('9_start')->nullable();
			$table->dateTime('9_end')->nullable();
			$table->integer('9_finish')->nullable();
			$table->string('10_gb', 100)->nullable();
			$table->string('10_gx', 100)->nullable();
			$table->string('10_time', 100)->nullable();
			$table->dateTime('10_start')->nullable();
			$table->dateTime('10_end')->nullable();
			$table->integer('10_finish')->nullable();
			$table->string('11_gb', 100)->nullable();
			$table->string('11_gx', 100)->nullable();
			$table->string('11_time', 100)->nullable();
			$table->dateTime('11_start')->nullable();
			$table->dateTime('11_end')->nullable();
			$table->integer('11_finish')->nullable();
			$table->string('12_gb', 100)->nullable();
			$table->string('12_gx', 100)->nullable();
			$table->string('12_time', 100)->nullable();
			$table->dateTime('12_start')->nullable();
			$table->dateTime('12_end')->nullable();
			$table->integer('12_finish')->nullable();
			$table->string('13_gb', 100)->nullable();
			$table->string('13_gx', 100)->nullable();
			$table->string('13_time', 100)->nullable();
			$table->dateTime('13_start')->nullable();
			$table->dateTime('13_end')->nullable();
			$table->integer('13_finish')->nullable();
			$table->string('14_gb', 100)->nullable();
			$table->string('14_gx', 100)->nullable();
			$table->string('14_time', 100)->nullable();
			$table->dateTime('14_start')->nullable();
			$table->dateTime('14_end')->nullable();
			$table->integer('14_finish')->nullable();
			$table->string('15_gb', 100)->nullable();
			$table->string('15_gx', 100)->nullable();
			$table->string('15_time', 100)->nullable();
			$table->dateTime('15_start')->nullable();
			$table->dateTime('15_end')->nullable();
			$table->integer('15_finish')->nullable();
			$table->string('16_gb', 100)->nullable();
			$table->string('16_gx', 100)->nullable();
			$table->string('16_time', 100)->nullable();
			$table->dateTime('16_start')->nullable();
			$table->dateTime('16_end')->nullable();
			$table->integer('16_finish')->nullable();
			$table->string('17_gb', 100)->nullable();
			$table->string('17_gx', 100)->nullable();
			$table->string('17_time', 100)->nullable();
			$table->dateTime('17_start')->nullable();
			$table->dateTime('17_end')->nullable();
			$table->integer('17_finish')->nullable();
			$table->string('18_gb', 100)->nullable();
			$table->string('18_gx', 100)->nullable();
			$table->string('18_time', 100)->nullable();
			$table->dateTime('18_start')->nullable();
			$table->dateTime('18_end')->nullable();
			$table->integer('18_finish')->nullable();
			$table->string('19_gb', 100)->nullable();
			$table->string('19_gx', 100)->nullable();
			$table->string('19_time', 100)->nullable();
			$table->dateTime('19_start')->nullable();
			$table->dateTime('19_end')->nullable();
			$table->integer('19_finish')->nullable();
			$table->string('20_gb', 100)->nullable();
			$table->string('20_gx', 100)->nullable();
			$table->string('20_time', 100)->nullable();
			$table->dateTime('20_start')->nullable();
			$table->dateTime('20_end')->nullable();
			$table->integer('20_finish')->nullable();
			$table->string('21_gb', 100)->nullable();
			$table->string('21_gx', 100)->nullable();
			$table->string('21_time', 100)->nullable();
			$table->dateTime('21_start')->nullable();
			$table->dateTime('21_end')->nullable();
			$table->integer('21_finish')->nullable();
			$table->string('22_gb', 100)->nullable();
			$table->string('22_gx', 100)->nullable();
			$table->string('22_time', 100)->nullable();
			$table->dateTime('22_start')->nullable();
			$table->dateTime('22_end')->nullable();
			$table->integer('22_finish')->nullable();
			$table->string('23_gb', 100)->nullable();
			$table->string('23_gx', 100)->nullable();
			$table->string('23_time', 100)->nullable();
			$table->dateTime('23_start')->nullable();
			$table->dateTime('23_end')->nullable();
			$table->integer('23_finish')->nullable();
			$table->string('24_gb', 100)->nullable();
			$table->string('24_gx', 100)->nullable();
			$table->string('24_time', 100)->nullable();
			$table->dateTime('24_start')->nullable();
			$table->dateTime('24_end')->nullable();
			$table->integer('24_finish')->nullable();
			$table->string('25_gb', 100)->nullable();
			$table->string('25_gx', 100)->nullable();
			$table->string('25_time', 100)->nullable();
			$table->dateTime('25_start')->nullable();
			$table->dateTime('25_end')->nullable();
			$table->integer('25_finish')->nullable();
			$table->string('26_gb', 100)->nullable();
			$table->string('26_gx', 100)->nullable();
			$table->string('26_time', 100)->nullable();
			$table->dateTime('26_start')->nullable();
			$table->dateTime('26_end')->nullable();
			$table->integer('26_finish')->nullable();
			$table->string('27_gb', 100)->nullable();
			$table->string('27_gx', 100)->nullable();
			$table->string('27_time', 100)->nullable();
			$table->dateTime('27_start')->nullable();
			$table->dateTime('27_end')->nullable();
			$table->integer('27_finish')->nullable();
			$table->string('28_gb', 100)->nullable();
			$table->string('28_gx', 100)->nullable();
			$table->string('28_time', 100)->nullable();
			$table->dateTime('28_start')->nullable();
			$table->dateTime('28_end')->nullable();
			$table->integer('28_finish')->nullable();
			$table->string('29_gb', 100)->nullable();
			$table->string('29_gx', 100)->nullable();
			$table->string('29_time', 100)->nullable();
			$table->dateTime('29_start')->nullable();
			$table->dateTime('29_end')->nullable();
			$table->integer('29_finish')->nullable();
			$table->string('30_gb', 100)->nullable();
			$table->string('30_gx', 100)->nullable();
			$table->string('30_time', 100)->nullable();
			$table->dateTime('30_start')->nullable();
			$table->dateTime('30_end')->nullable();
			$table->integer('30_finish')->nullable();
			$table->string('31_gb', 100)->nullable();
			$table->string('31_gx', 100)->nullable();
			$table->string('31_time', 100)->nullable();
			$table->dateTime('31_start')->nullable();
			$table->dateTime('31_end')->nullable();
			$table->integer('31_finish')->nullable();
			$table->timestamps();
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('gongr_finishes');
	}

}
